begin tran
declare @kerRate dec(12, 4)
select @kerRate = exch_rate from igsnet.dbo.ms_currency where cur_code ='KER'
select @kerRate
update ms_style set cost = ceiling((a.cost*1.1*1000)/@kerRate)
from ms_style_mobil a
where ( ms_style.style_id = a.id or ms_style.style_no = a.style_no) and ms_style.cost > 1000
select * from igsnet.dbo.ms_style where style_no = 'C140311222856                                             '
rollback tran



